﻿<?xml version="1.0" encoding="UTF-8"?>
<form xmlns="http://www.evolutility.com" title="领料登记" icon="cube.gif" description="ExportOrImport">
  <data dbtable="MRP_ImportExport" splogin="asp.net membership" dbcolumnpk="ID" dbwhere="ExportOrImport=-1 and Exists(Select * from MRP_MaterialMain where MRP_MaterialMain.ID=T.MaterialID and MRP_MaterialMain.MType>5)" sppaging="EvoSP_PagedItem @SQLselect, @SQLtable, @SQLfrom, @SQLwhere, @SQLorderby, @SQLpk, @pageid, @pagesize" />
  <panel userid="1" ppos="1" label="领取材料" width="100">
    <field id="36" type="text" typeid="5" label="领料单号" dbcolumn="BillNO" dbcolumnread="BillNO" supportsession="outM" maxlength="128" readonly="2" required="1" optional="" fpos="10" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="153"  type="lov" typeid="5" label="材料名称" htmlcontrol="textselect"   dbcolumn="MaterialID" jsdependency ="MyMRP.change_MaterialExportFields" dbcolumnread="NameAndCode" dbcolumnreadlov="NameAndCode" dbwherelov="View_MaterialNameAndCode.MType>5" dbtablelov="View_MaterialNameAndCode" maxlength="2" readonly="0" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="70" />
    <field id="154" type="decimal" typeid="10" label="总数量" min="1" dbcolumn="QuantityOfStockUnit" jsdependency ="MyMRP.change_MaterialExportFields" jsvalidation="MyMRP.check_InStock" dbcolumnread="QuantityOfStockUnit" maxlength="16" readonly="0" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="38" type="formula" typeid="5" label="单位" dbcolumn="Select top 1 DisplayText FROM MRP_MaterialMain join View_UnitType_List on Unit=View_UnitType_List.ID where MRP_MaterialMain.ID=T.MaterialID " dbcolumnread="PurchaseUnit1"
   maxlength="0" readonly="1" required="" optional="" fpos="30" search="0" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="154" type="decimal" typeid="10" label="理论重量(kg)" dbcolumn="Weight" dbcolumnread="Weight" defaultvalue="0" maxlength="8" readonly="1" required="1" optional="" fpos="20" search="1" searchadv="1" searchlist="1" height="1" width="20" />
    <field id="156" type="textmultiline" typeid="6" label="备注" dbcolumn="Note" dbcolumnread="Note" defaultvalue="一共XXX根，每根XXX米" maxlength="256" readonly="0" required="" optional="" fpos="40" search="1" searchadv="1" searchlist="1" height="3" width="100" />
    <field id="158" type="datetime" typeid="17" label="录入时间" defaultvalue="_now" format="{0:d} {0:t}" dbcolumn="CreatedDate" dbcolumnread="CreatedDate" maxlength="4" readonly="0" required="2" optional="" fpos="60" search="1" searchadv="1" searchlist="" height="1" width="30" />
    <field id="155" type="lov" typeid="5" label="出库" dbcolumn="ExportOrImport" dbcolumnread="DisplayText"
       dbtablelov="View_ExportOrImport_List" dbcolumnreadlov="DisplayText" defaultvalue="-1" maxlength="0" readonly="1" required="1" optional="" fpos="30" search="0" searchadv="1" searchlist="0" height="1" width="20" />
  </panel>
</form>
